0

Untitled2.ipynb

No Headings

The table of contents shows headings in notebooks and supported files.

Skip to Main
Jupyter

Untitled2

Last Checkpoint: 1 minute ago
  • File
  • Edit
  • View
  • Run
  • Kernel
  • Settings
  • Help
JupyterLab
Python [conda env:base] *
Kernel status: Idle
image/svg+xml
    [6]:
    Selection deleted
    import pandas as pd

    data = {
    'Player': ['Virat Kohli', 'Rohit Sharma', 'Jasprit Bumrah', 'KL Rahul', 'Ravindra Jadeja'],
    'Matches': [250, 230, 180, 160, 200],
    'Runs': [12000, 11000, 1000, 6500, 3000],
    'Wickets': [4, 8, 350, 2, 200],
    'Innings': [230, 220, 50, 150, 180],
    'Not_Outs': [40, 35, 10, 20, 30] # Added Not Out data
    }

    # Creating DataFrame
    df = pd.DataFrame(data)
    print(df)
                Player  Matches   Runs  Wickets  Innings  Not_Outs
    0      Virat Kohli      250  12000        4      230        40
    1     Rohit Sharma      230  11000        8      220        35
    2   Jasprit Bumrah      180   1000      350       50        10
    3         KL Rahul      160   6500        2      150        20
    4  Ravindra Jadeja      200   3000      200      180        30
    
    [8]:
    team_total_runs = df['Runs'].sum()
    print("Team Total Runs:", team_total_runs)
    Team Total Runs: 33500
    
    [10]:
    df['Batting_Average'] = df.apply(lambda row: row['Runs'] / (row['Innings'] - row['Not_Outs']) if (row['Innings'] - row['Not_Outs']) > 0 else 0, axis=1)
    print(df)
                Player  Matches   Runs  Wickets  Innings  Not_Outs  \
    0      Virat Kohli      250  12000        4      230        40   
    1     Rohit Sharma      230  11000        8      220        35   
    2   Jasprit Bumrah      180   1000      350       50        10   
    3         KL Rahul      160   6500        2      150        20   
    4  Ravindra Jadeja      200   3000      200      180        30   
    
       Batting_Average  
    0        63.157895  
    1        59.459459  
    2        25.000000  
    3        50.000000  
    4        20.000000  
    
    [12]:
    df['Bowling_Strike_Rate'] = df.apply(lambda row: (row['Innings'] * 6) / row['Wickets'] if row['Wickets'] > 0 else 0, axis=1)
    print(df)
                Player  Matches   Runs  Wickets  Innings  Not_Outs  \
    0      Virat Kohli      250  12000        4      230        40   
    1     Rohit Sharma      230  11000        8      220        35   
    2   Jasprit Bumrah      180   1000      350       50        10   
    3         KL Rahul      160   6500        2      150        20   
    4  Ravindra Jadeja      200   3000      200      180        30   
    
       Batting_Average  Bowling_Strike_Rate  
    0        63.157895           345.000000  
    1        59.459459           165.000000  
    2        25.000000             0.857143  
    3        50.000000           450.000000  
    4        20.000000             5.400000  
    
    [18]:
    0
    [20]:
    2
    [22]:
    0
    [24]:
    2
                Player  Points
    0      Virat Kohli     130
    1     Rohit Sharma     128
    2   Jasprit Bumrah     713
    3         KL Rahul      71
    4  Ravindra Jadeja     433
    
    [ ]:

    -

    Variables

    Callstack

      Breakpoints

      Source

      9
      1

      Kernel Sources

      Common Tools
      No metadata.
      Advanced Tools
      No metadata.
      Anaconda Assistant
      AI-powered coding, insights and debugging in your notebooks.
      To enable the following extensions, create an account or sign in.
      • Anaconda Assistant
        4.1.0
      • Coming soon!
      • Data Catalogs
      • Panel Deployments
      • Sharing
      Already have an account? Sign In
      For more information, read our Anaconda Assistant documentation.
      Alt+[
      Alt+]
      Alt+End
      • Assistant
      • Open Anaconda Assistant
        Ctrl+Shift+A
      • Console
      • Change Kernel…
      • Clear Console Cells
      • Close and Shut Down…
      • Insert Line Break
      • Interrupt Kernel
      • New Console
      • Restart Kernel…
      • Run Cell (forced)
      • Run Cell (unforced)
      • Show All Kernel Activity
      • Debugger
      • Breakpoints on exception
      • Evaluate Code
        Evaluate Code
      • Next
        Next
        F10
      • Pause
        Pause
        F9
      • Step In
        Step In
        F11
      • Step Out
        Step Out
        Shift+F11
      • Terminate
        Terminate
        Shift+F9
      • Display Languages
      • English
        English
      • File Operations
      • Autosave Documents
      • Download
        Download the file to your computer
      • Reload Notebook from Disk
        Reload contents from disk
      • Revert Notebook to Checkpoint…
        Revert contents to previous checkpoint
      • Save Notebook
        Save and create checkpoint
        Ctrl+S
      • Save Notebook As…
        Save with new path
        Ctrl+Shift+S
      • Trust HTML File
        Whether the HTML file is trusted. Trusting the file allows scripts to run in it, which may result in security risks. Only enable for files you trust.
      • Help
      • About Jupyter Notebook
      • Jupyter Reference
      • JupyterLab FAQ
      • JupyterLab Reference
      • Launch Jupyter Notebook File Browser
      • Markdown Reference
      • Show Keyboard Shortcuts…
        Show relevant keyboard shortcuts for the current active widget
        Ctrl+Shift+H
      • Image Viewer
      • Flip image horizontally
        H
      • Flip image vertically
        V
      • Invert Colors
        I
      • Reset Image
        0
      • Rotate Clockwise
        ]
      • Rotate Counterclockwise
        [
      • Zoom In
        =
      • Zoom Out
        -
      • Kernel Operations
      • Shut Down All Kernels…
      • Main Area
      • Close All Other Tabs
      • Close Tab
        Alt+W
      • Close Tabs to Right
      • End Search
        Esc
      • Find Next
        Ctrl+G
      • Find Previous
        Ctrl+Shift+G
      • Find…
        Ctrl+F
      • Log Out
        Log out of Jupyter Notebook
      • Search in Selection
        Alt+L
      • Shut Down
        Shut down Jupyter Notebook
      • Mode
      • Toggle Zen Mode
      • Notebook Cell Operations
      • Change to Code Cell Type
        Y
      • Change to Heading 1
        1
      • Change to Heading 2
        2
      • Change to Heading 3
        3
      • Change to Heading 4
        4
      • Change to Heading 5
        5
      • Change to Heading 6
        6
      • Change to Markdown Cell Type
        M
      • Change to Raw Cell Type
        R
      • Clear Cell Output
        Clear outputs for the selected cells
      • Collapse All Code
      • Collapse All Outputs
      • Collapse Selected Code
      • Collapse Selected Outputs
      • Copy Cell
        Copy this cell
        C
      • Cut Cell
        Cut this cell
        X
      • Delete Cell
        Delete this cell
        D, D
      • Disable Scrolling for Outputs
      • Enable Scrolling for Outputs
      • Expand All Code
      • Expand All Outputs
      • Expand Selected Code
      • Expand Selected Outputs
      • Extend Selection Above
        Shift+K
      • Extend Selection Below
        Shift+J
      • Extend Selection to Bottom
        Shift+End
      • Extend Selection to Top
        Shift+Home
      • Insert Cell Above
        Insert a cell above
        A
      • Insert Cell Below
        Insert a cell below
        B
      • Insert Heading Above Current Heading
        Shift+A
      • Insert Heading Below Current Heading
        Shift+B
      • Merge Cell Above
        Ctrl+Backspace
      • Merge Cell Below
        Ctrl+Shift+M
      • Merge Selected Cells
        Shift+M
      • Move Cell Down
        Move this cell down
        Ctrl+Shift+Down
      • Move Cell Up
        Move this cell up
        Ctrl+Shift+Up
      • Paste Cell Above
        Paste this cell from the clipboard
      • Paste Cell and Replace
      • Paste Cell Below
        Paste this cell from the clipboard
        V
      • Redo Cell Operation
        Shift+Z
      • Render Side-by-Side
        Shift+R
      • Run Selected Cell
        Run this cell and advance
        Shift+Enter
      • Run Selected Cell and Do not Advance
        Ctrl+Enter
      • Run Selected Cell and Insert Below
        Alt+Enter
      • Run Selected Text or Current Line in Console
      • Select Cell Above
        K
      • Select Cell Below
        J
      • Select Heading Above or Collapse Heading
        Left
      • Select Heading Below or Expand Heading
        Right
      • Set side-by-side ratio
      • Split Cell
        Ctrl+Shift+-
      • Undo Cell Operation
        Z
      • Notebook Operations
      • Access Next Kernel History Entry
        Alt+Down
      • Access Previous Kernel History Entry
        Alt+Up
      • Change Kernel…
      • Clear Outputs of All Cells
        Clear all outputs of all cells
      • Close and Shut Down Notebook…
      • Collapse All Headings
        Ctrl+Shift+Left
      • Deselect All Cells
      • Edit Notebook Metadata
      • Enter Command Mode
        Ctrl+M
      • Enter Edit Mode
        Enter
      • Expand All Headings
        Ctrl+Shift+Right
      • Interrupt Kernel
        Interrupt the kernel
      • New Console for Notebook
      • New Notebook
        Create a new notebook
      • Open with Panel in New Browser Tab
      • Preview Notebook with Panel
      • Reconnect to Kernel
      • Render All Markdown Cells
      • Restart Kernel and Clear Outputs of All Cells…
        Restart the kernel and clear all outputs of all cells
      • Restart Kernel and Debug…
        Restart Kernel and Debug…
      • Restart Kernel and Run All Cells…
        Restart the kernel and run all cells
      • Restart Kernel and Run up to Selected Cell…
      • Restart Kernel…
        Restart the kernel
      • Run All Above Selected Cell
      • Run All Cells
        Run all cells
      • Run Selected Cell and All Below
      • Save and Export Notebook: Asciidoc
      • Save and Export Notebook: Executable Script
      • Save and Export Notebook: HTML
      • Save and Export Notebook: LaTeX
      • Save and Export Notebook: Markdown
      • Save and Export Notebook: PDF
      • Save and Export Notebook: Qtpdf
      • Save and Export Notebook: Qtpng
      • Save and Export Notebook: ReStructured Text
      • Save and Export Notebook: Reveal.js Slides
      • Save and Export Notebook: Webpdf
      • Select All Cells
        Ctrl+A
      • Show Line Numbers
      • Toggle Collapse Notebook Heading
      • Trust Notebook
      • Other
      • Open in JupyterLab
        JupyterLab
      • Plugin Manager
      • Advanced Plugin Manager
      • Terminal
      • Decrease Terminal Font Size
      • Increase Terminal Font Size
      • New Terminal
        Start a new terminal session
      • Refresh Terminal
        Refresh the current terminal session
      • Use Terminal Theme: Dark
        Set the terminal theme
      • Use Terminal Theme: Inherit
        Set the terminal theme
      • Use Terminal Theme: Light
        Set the terminal theme
      • Text Editor
      • Decrease Font Size
      • Increase Font Size
      • New Markdown File
        Create a new markdown file
      • New Python File
        Create a new Python file
      • New Text File
        Create a new text file
      • Spaces: 1
      • Spaces: 2
      • Spaces: 4
      • Spaces: 4
      • Spaces: 8
      • Theme
      • Decrease Code Font Size
      • Decrease Content Font Size
      • Decrease UI Font Size
      • Increase Code Font Size
      • Increase Content Font Size
      • Increase UI Font Size
      • Set Preferred Dark Theme: JupyterLab Dark
      • Set Preferred Dark Theme: JupyterLab Dark High Contrast
      • Set Preferred Dark Theme: JupyterLab Light
      • Set Preferred Light Theme: JupyterLab Dark
      • Set Preferred Light Theme: JupyterLab Dark High Contrast
      • Set Preferred Light Theme: JupyterLab Light
      • Synchronize Styling Theme with System Settings
      • Theme Scrollbars
      • Use Theme: JupyterLab Dark
      • Use Theme: JupyterLab Dark High Contrast
      • Use Theme: JupyterLab Light
      • View
      • File Browser
      • Open JupyterLab
      • Show Anaconda Assistant
        Show Show Anaconda Assistant in the right sidebar
      • Show Debugger
        Show Show Debugger in the right sidebar
      • Show Header
      • Show Notebook Tools
        Show Show Notebook Tools in the right sidebar
      • Show Table of Contents
        Show Show Table of Contents in the left sidebar